Task Two | Employee_Salaries | Data Visualization

by Gasm Elbary Mohamed

Task: create a dashboard to share the findings with the management.

The dashboard should include:

  1. A map of the gross pay by zip code
  2. A bar chart of gross pay by gender
  3. A bar chart of gross pay by number of years being hired
  4. A treemap of overtime pay and department name

1. Understand the data

To view the dataset and check if there needs any cleaning.

1.1 Import the libraries

1.2 Load the data

1.3 View the dataset and its information




There are missing values in the Position Under-Filled column only, and that could be explained by saying that means the prespective emplyees have no position under-filled. Therefore, there are no missing data in columns of interest to carry out this task.

The data needs no cleaning, and we can carry out the visualization task.


2 Data Visualization

2.1 A map of the gross pay by zip code

By checking the names of the cities on the dataset, I could conclude that the data is from Maryland, USA. To draw the gross pay on a map, I need to know the coordination of the available zip codes; and that is usually available in a GeoJson file. Searching online, I could find a GeoJson of Maryland on the following link.

2.2 A bar chart of gross pay by gender (total)

2.3 A bar chart of gross pay by number of years being hired

2.4 A treemap of overtime pay and department name